This page documents the steps taken to upgrade the Confluence installation so that it could be migrated to the Confluence Cloud Service hosted by Atlassian.

The starting point for the upgrade is the following:

1. Confluence version 2.7 running on the server oceana.mbari.org
2. Authentication is using the Crowd service also located on oceana.mbari.org (database is on solstice)
3. The database that confluence is using is the Confluence database on solstice.shore.mbari.org

Path

The path for our install appears to be: 2.7 -> 2.7.4 -> 3.5.17 -> 5.0.3 -> latest (5.8 at time of writing this)

Steps

1. I.S. created a new VM named pompeii.shore.mbari.org that I will use to do all the stepwise upgrades
2. Java 1.6.0_36 was installed, so I asked for an update to the latest 1.8 version
3. I.S. created four databases for the upgrade path.
4. Per the installation instructions, for each of these databases, I performed the following using Aqua Data Studio

   ALTER DATABASE <database_name> COLLATE SQL_Latin1_General_CP1_CS_AS
   

5. Per the installation instructions, for each database, I ran:

   ALTER DATABASE <database_name> SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE;
   

6. I VNC'd into pompeii.shore.mbari.org and fired up Firefox.
7. I downloaded the .tar.gz versions of the standalone for all the versions listed above.
8. I went to the Confluence Administration panel and went to Backup and Restore
9. I selected both the Backup check boxes and clicked "Backup"
10. The backup completed and I downloaded the 1.3 GB file.
11. I then SCP'd that file to pompeii in case I can do a local restore which will be much faster. (/home/kgomes/confluence_upgrade)